package bunyang;

import common.db.*;
import common.main.*;

public class BunyangInfoBean extends MainBean
{
	public void funcExecute() throws Exception
	{
		String gcode = (String)inputTable.get("gcode");
		
		queryBuffer = new StringBuffer("");
		queryBuffer.append("SELECT a.GCODE, a.GNAME, a.PURCHARSE_WAY, a.STOCK_VALUE, a.COST, a.GOODS_PRICE, a.SAVING_POINT, a.MK_DATE, a.EX_DATE, a.SE_DATE, a.TE_DATE, a.SELL_CNT, a.REG_ID, a.REG_DATE, a.REG_IP, a.UPD_ID, a.UPD_DATE, a.UPD_IP, b.IMG_PATH, c.BIG_IMG, c.IMG1,c.IMG2, c.IMG3, c.IMG4, c.BNAME, c.JUYO, c.DAMDANG, c.TEL, c.CELL, c.IMDAE, c.SUHAK, c.YESANG, c.STOCK, c.GOODSINFOIMGPATH, c.FARMINTRO, c.FARMERINTRO, c.FARMERIMGPATH, c.BUNYANGPRICE, c.BUNYANGCONTENTS FROM GOODS a, GOODS_IMG b, BUNYANG_INFO c WHERE a.GCODE='"+gcode+"' AND a.GCODE=b.GCODE_SEQ");

		DBExecute dbe = new DBExecute(queryBuffer.toString());
		outputList = dbe.getDataList();
	}
}
